/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.minhphuong.dal;

import com.minhphuong.entities.*;
import java.util.List;
import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;

/**
 *
 * @author QuocMinh
 */
public class HangDAL {

    public static List<Hang> getAllHang() {
        List<Hang> listHang = null;
        Session session = null;
        try {
            session = HelperDAL.GetSession();
            org.hibernate.Transaction tx = session.beginTransaction();
            Query q = session.createQuery("from Hang");
            listHang = (List<Hang>) q.list();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            for (Hang hang : listHang) {
                Hibernate.initialize(hang.getSanPhams().size());
            }
            session.flush();
            session.close();
        }
        return listHang;
    }
    public static Hang getHangByID(int id) {
        Hang hang = null;
        Session session = null;

        try {
            session = HelperDAL.GetSession();
            org.hibernate.Transaction tx = session.beginTransaction();
            Query q = session.createQuery("from Hang where MaH=:id").setInteger("id", id);
            hang = (Hang) q.list().get(0);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
           
            session.flush();
            session.close();
        }

        return hang;
        //throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
    }

}
